Last modified time: September 27, 2021
Assumption: 1 kBtu=3.412 KWH
## # A tibble: 54 × 5
## # Groups: YEAR [5]
## YEAR MONTH TOTALKWH Residential_Electric_kBtu Time
## <dbl> <dbl> <dbl> <dbl> <date>
## 1 2017 1 2696632298 9200909401. 2017-01-01
## 2 2017 2 2089405296 7129050870. 2017-02-01
## 3 2017 3 2007875145 6850869995. 2017-03-01
## 4 2017 4 1838107707 6271623496. 2017-04-01
## 5 2017 5 2070656073 7065078521. 2017-05-01
## 6 2017 6 2615607826 8924453902. 2017-06-01
## 7 2017 7 3113124827 10621981910. 2017-07-01
## 8 2017 8 2995761408 10221537924. 2017-08-01
## 9 2017 9 5072659238 17307913320. 2017-09-01
## 10 2017 10 1956786021 6676553904. 2017-10-01
## # … with 44 more rows
Assumption: 1 kBtu=100.00039 THM
## # A tibble: 54 × 5
## # Groups: YEAR [5]
## YEAR MONTH TOTALTHM Residential_Gas_kBtu Time
## <dbl> <dbl> <dbl> <dbl> <date>
## 1 2017 1 332986863 33298816165. 2017-01-01
## 2 2017 2 214756795 21475763255. 2017-02-01
## 3 2017 3 167698331 16769898502. 2017-03-01
## 4 2017 4 128910844 12891134675. 2017-04-01
## 5 2017 5 93587412 9358777699. 2017-05-01
## 6 2017 6 74050205 7405049380. 2017-06-01
## 7 2017 7 70934300 7093457664. 2017-07-01
## 8 2017 8 69535451 6953572219. 2017-08-01
## 9 2017 9 136754090 13675462334. 2017-09-01
## 10 2017 10 92544327 9254468792. 2017-10-01
## # … with 44 more rows
List the electricity and gas consumption of each month from the first quarter of 2017 to the second quarter of 2021 in chronological order.
Take kBtu as the unit for statistics.
Time window: from the first quarter of 2017 to the second quarter of 2021
Time window: from the first quarter of 2017 to the second quarter of 2021
In this part, a series of necessary indicators are established.
In order to conduct cross-analysis between data, I proposed a total of 7 Hypotheses and drew charts of them separately for observation and verification.
Hypothesis 1: The epidemic has an impact on the total commercial energy consumption; Hypothesis 2: The epidemic has an impact on the total residential energy consumption; Hypothesis 3: The epidemic has an impact on the ratio of residential and commercial energy consumption; Hypothesis 4: The epidemic has an impact on the ratio of gas consumption to electricity consumption ( commercial); Hypothesis 5: The epidemic has an impact on the ratio of gas consumption to electricity consumption ( residential); Hypothesis 6: The epidemic has an impact on total gas consumption; Hypothesis 7: The epidemic has an impact on total electricity consumption
For the above seven hypotheses, I added 7 indicators to describe these them separately.
However, by observing the drawn charts, I personally think that only the following three hypotheses are significantly established. (This does not mean that other hypotheses are completely untenable, but to a certain extent, no definite conclusion can be drawn based on the current data and analysis.)
Hypothesis 3: The epidemic has an impact on the ratio of residential and commercial energy consumption; Hypothesis 6: The epidemic has an impact on total gas consumption; Hypothesis 7: The epidemic has an impact on total electricity consumption
Charts and analysis are as follows:
*The World Health Organization (WHO) declared a Public Health Emergency of International Concern on 30 January 2020, and a pandemic on 11 March 2020.
2.2 Comment on observable changes in energy consumption that may be attributable to the COVID-19 pandemic
Comment 1
Comment 2
Comment 3
Comment 4